/* Do-File for Replication: 

GOVERNANCE IN MANAGING PUBLIC HEALTH 
RESOURCES IN BRAZILIAN MUNICIPALITIES

GEORGE AVELINO FILHO
LORENA G BARBERIA
CIRO BIDERMAN
*/


* Table 1 - Regression results
regress ind_corrup_n anos_cons eleccomp2 d_reelected htransfers lnpop  poverty [pweight=total_os]  if total_os>2, robust
estimates store basic
regress  ind_corrup_n anos_cons  eleccomp2 d_reelected htransfers  lnpop  poverty personnel [pweight=total_os]  if total_os>2, robust
estimates store pers
regress  ind_corrup_n anos_cons  eleccomp2 d_reelected htransfers  lnpop  poverty medsupplies [pweight=total_os] if total_os>2, robust
estimates store meds
regress  ind_corrup_n anos_cons  eleccomp2 d_reelected htransfers  lnpop  poverty investment [pweight=total_os] if total_os>2, robust
estimates store inv
regress  ind_corrup_n anos_cons  eleccomp2 d_reelected htransfers  lnpop  poverty providers [pweight=total_os] if total_os>2, robust
estimates store prov
regress  ind_corrup_n anos_cons  eleccomp2 d_reelected htransfers  lnpop  poverty personnel medsupplies investment providers[pweight=total_os] if total_os>2, robust

estimates store all

outreg2 [basic pers meds inv prov all] using tablehpp_npw, replace dec(3) see e(all)

* Appendix 2 - Summary Statistics
sum total_os ind_corrup_n ind_corrup_m tot_montante anos_cons eleccomp d_reelected population poverty htransfers  personnel medsupplies investment providers if total_os>2
